/*
 Navicat Premium Data Transfer

 Source Server         : remote
 Source Server Type    : MySQL
 Source Server Version : 80022 (8.0.22-txsql)
 Source Host           : 127.0.0.1:3306
 Source Schema         : enterprise-assets

 Target Server Type    : MySQL
 Target Server Version : 80022 (8.0.22-txsql)
 File Encoding         : 65001

 Date: 12/06/2024 00:27:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for config
-- ----------------------------
DROP TABLE IF EXISTS `config`;
CREATE TABLE `config` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL COMMENT '配置参数名称',
  `value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='配置文件';

-- ----------------------------
-- Records of config
-- ----------------------------
BEGIN;
INSERT INTO `config` (`id`, `name`, `value`) VALUES (1, 'picture1', 'http://localhost:8080/springboot4j9k2/upload/picture1.jpg');
INSERT INTO `config` (`id`, `name`, `value`) VALUES (2, 'picture2', 'http://localhost:8080/springboot4j9k2/upload/picture2.jpg');
INSERT INTO `config` (`id`, `name`, `value`) VALUES (3, 'picture3', 'http://localhost:8080/springboot4j9k2/upload/picture3.jpg');
INSERT INTO `config` (`id`, `name`, `value`) VALUES (6, 'homepage', NULL);
COMMIT;

-- ----------------------------
-- Table structure for token
-- ----------------------------
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='token表';

-- ----------------------------
-- Records of token
-- ----------------------------
BEGIN;
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (1, 1, 'abo', 'users', '管理员', 'tzdso2gbgntzozub8jl8ex3m4badj5fp', '2024-03-24 17:09:37', '2024-05-25 05:31:38');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (2, 11, '用户1', 'yonghu', '用户', '66jdl64nnnkzvupn4917tuq2ipen5p0t', '2024-04-13 14:39:58', '2024-05-12 17:07:14');
INSERT INTO `token` (`id`, `userid`, `username`, `tablename`, `role`, `token`, `addtime`, `expiratedtime`) VALUES (3, 1714544016073, '212', 'yonghu', '用户', 'i59x2e0ri7u5qtqmirqb3ai3jrt7ldd7', '2024-05-20 08:40:11', '2024-05-20 09:40:14');
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`id`, `username`, `password`, `role`, `addtime`) VALUES (1, 'abo', 'abo', '管理员', '2021-05-11 09:16:58');
COMMIT;

-- ----------------------------
-- Table structure for yonghu
-- ----------------------------
DROP TABLE IF EXISTS `yonghu`;
CREATE TABLE `yonghu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `yonghuming` varchar(200) NOT NULL COMMENT '用户名',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xingming` varchar(200) NOT NULL COMMENT '姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `touxiang` varchar(200) DEFAULT NULL COMMENT '头像',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`),
  UNIQUE KEY `yonghuming` (`yonghuming`)
) ENGINE=InnoDB AUTO_INCREMENT=17145440160732 DEFAULT CHARSET=utf8 COMMENT='用户';

-- ----------------------------
-- Records of yonghu
-- ----------------------------
BEGIN;
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (11, '2021-05-11 09:16:58', '用户1', '123456', '姓名1', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang1.jpg', '13823888881', '773890001@qq.com', '440300199101010001', '否', 'scs');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (12, '2021-05-11 09:16:58', '用户2', '123456', '姓名2', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang2.jpg', '13823888882', '773890002@qq.com', '440300199202020002', '否', 'zsfa');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (13, '2021-05-11 09:16:58', '用户3', '123456', '姓名3', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang3.jpg', '13823888883', '773890003@qq.com', '440300199303030003', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (14, '2021-05-11 09:16:58', '用户4', '123456', '姓名4', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang4.jpg', '13823888884', '773890004@qq.com', '440300199404040004', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (15, '2021-05-11 09:16:58', '用户5', '123456', '姓名5', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang5.jpg', '13823888885', '773890005@qq.com', '440300199505050005', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (16, '2021-05-11 09:16:58', '用户6', '123456', '姓名6', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang6.jpg', '13823888886', '773890006@qq.com', '440300199606060006', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (111, '2021-05-11 09:16:58', '用户11', '123456', '姓名11', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang1.jpg', '13823888881', '773890001@qq.com', '440300199101010001', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (121, '2021-05-11 09:16:58', '用户21', '123456', '姓名21', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang2.jpg', '13823888882', '773890002@qq.com', '440300199202020002', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (131, '2021-05-11 09:16:58', '用户31', '123456', '姓名31', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang3.jpg', '13823888883', '773890003@qq.com', '440300199303030003', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (141, '2021-05-11 09:16:58', '用户41', '123456', '姓名411', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang4.jpg', '13823888884', '773890004@qq.com', '440300199404040004', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (151, '2021-05-11 09:16:58', '用户51', '123456', '姓名51', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang5.jpg', '13823888885', '773890005@qq.com', '440300199505050005', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (161, '2021-05-11 09:16:58', '用户61', '123456', '姓名61', '男', 'http://localhost:8080/springboot4j9k2/upload/yonghu_touxiang6.jpg', '13823888886', '773890006@qq.com', '440300199606060006', '是', '');
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (1714544016073, '2024-05-01 14:13:36', '212', '12', '12', '男', 'http://localhost:8080/springboot4j9k2/upload/1714543998755.png', '17610830867', '12@163.com', NULL, '是', NULL);
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (1715500023241, '2024-05-12 15:47:03', '用户15', '123', '姓名15', '男', NULL, '13823888881', NULL, NULL, '是', NULL);
INSERT INTO `yonghu` (`id`, `addtime`, `yonghuming`, `mima`, `xingming`, `xingbie`, `touxiang`, `shouji`, `youxiang`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (17145440160731, '2024-05-01 14:13:36', '2121', '121', '12', '男', 'http://localhost:8080/springboot4j9k2/upload/1714543998755.png', '17610830867', '12@163.com', NULL, '否', NULL);
COMMIT;

-- ----------------------------
-- Table structure for zichanfenlei
-- ----------------------------
DROP TABLE IF EXISTS `zichanfenlei`;
CREATE TABLE `zichanfenlei` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zichanfenlei` varchar(200) NOT NULL COMMENT '资产分类',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zichanfenlei` (`zichanfenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=1716164280431 DEFAULT CHARSET=utf8 COMMENT='资产分类';

-- ----------------------------
-- Records of zichanfenlei
-- ----------------------------
BEGIN;
INSERT INTO `zichanfenlei` (`id`, `addtime`, `zichanfenlei`) VALUES (21, '2021-05-11 09:16:58', '资产分类1');
INSERT INTO `zichanfenlei` (`id`, `addtime`, `zichanfenlei`) VALUES (22, '2021-05-11 09:16:58', '资产分类2');
INSERT INTO `zichanfenlei` (`id`, `addtime`, `zichanfenlei`) VALUES (23, '2021-05-11 09:16:58', '资产分类3');
INSERT INTO `zichanfenlei` (`id`, `addtime`, `zichanfenlei`) VALUES (24, '2021-05-11 09:16:58', '资产分类4');
INSERT INTO `zichanfenlei` (`id`, `addtime`, `zichanfenlei`) VALUES (25, '2021-05-11 09:16:58', '资产分类5');
INSERT INTO `zichanfenlei` (`id`, `addtime`, `zichanfenlei`) VALUES (26, '2021-05-11 09:16:58', '资产分类6');
COMMIT;

-- ----------------------------
-- Table structure for zichanguihai
-- ----------------------------
DROP TABLE IF EXISTS `zichanguihai`;
CREATE TABLE `zichanguihai` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zichanbianhao` varchar(200) DEFAULT NULL COMMENT '资产编号',
  `shebeimingcheng` varchar(200) DEFAULT NULL COMMENT '设备名称',
  `zichanfenlei` varchar(200) DEFAULT NULL COMMENT '资产分类',
  `zichantupian` varchar(200) DEFAULT NULL COMMENT '资产图片',
  `shuliang` int NOT NULL COMMENT '数量',
  `guihairiqi` date DEFAULT NULL COMMENT '归还日期',
  `guihaibeizhu` varchar(200) DEFAULT NULL COMMENT '归还备注',
  `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1712993615678 DEFAULT CHARSET=utf8 COMMENT='资产归还';

-- ----------------------------
-- Records of zichanguihai
-- ----------------------------
BEGIN;
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (51, '2021-05-11 09:16:58', '资产编号1', '设备名称1', '资产分类1', 'http://localhost:8080/springboot4j9k2/upload/zichanguihai_zichantupian1.jpg', 1, '2021-05-11', '归还备注1', '用户名1', '姓名1', '13823888881', '440300199101010001', '是', '');
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (52, '2021-05-11 09:16:58', '资产编号2', '设备名称2', '资产分类2', 'http://localhost:8080/springboot4j9k2/upload/zichanguihai_zichantupian2.jpg', 2, '2021-05-11', '归还备注2', '用户名2', '姓名2', '13823888882', '440300199202020002', '是', '');
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (53, '2021-05-11 09:16:58', '资产编号3', '设备名称3', '资产分类3', 'http://localhost:8080/springboot4j9k2/upload/zichanguihai_zichantupian3.jpg', 3, '2021-05-11', '归还备注3', '用户名3', '姓名3', '13823888883', '440300199303030003', '是', '');
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (54, '2021-05-11 09:16:58', '资产编号4', '设备名称4', '资产分类4', 'http://localhost:8080/springboot4j9k2/upload/zichanguihai_zichantupian4.jpg', 4, '2021-05-11', '归还备注4', '用户名4', '姓名4', '13823888884', '440300199404040004', '是', '');
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (55, '2021-05-11 09:16:58', '资产编号5', '设备名称5', '资产分类5', 'http://localhost:8080/springboot4j9k2/upload/zichanguihai_zichantupian5.jpg', 5, '2021-05-11', '归还备注5', '用户名5', '姓名5', '13823888885', '440300199505050005', '是', '');
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (56, '2021-05-11 09:16:58', '资产编号6', '设备名称6', '资产分类6', 'http://localhost:8080/springboot4j9k2/upload/zichanguihai_zichantupian6.jpg', 6, '2021-05-11', '归还备注6', '用户名6', '姓名6', '13823888886', '440300199606060006', '是', '');
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (1712993394479, '2024-04-13 15:29:54', '资产编号4', '设备名称4', '资产分类4', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian4.jpg', 1, '2024-04-13', NULL, '用户1', '姓名1', '13823888881', '440300199101010001', '否', NULL);
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (1712993423215, '2024-04-13 15:30:22', '资产编号5', '设备名称5', '资产分类5', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian5.jpg', 2, '2024-04-13', NULL, '用户1', '姓名1', '13823888881', '440300199101010001', '否', NULL);
INSERT INTO `zichanguihai` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `guihairiqi`, `guihaibeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (1712993615677, '2024-04-13 15:33:38', '资产编号1', '设备名称1', '资产分类1', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian1.jpg', 1, '2024-04-13', NULL, '用户1', '姓名1', '13823888881', '440300199101010001', '是', NULL);
COMMIT;

-- ----------------------------
-- Table structure for zichanjiechu
-- ----------------------------
DROP TABLE IF EXISTS `zichanjiechu`;
CREATE TABLE `zichanjiechu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zichanbianhao` varchar(200) DEFAULT NULL COMMENT '资产编号',
  `shebeimingcheng` varchar(200) DEFAULT NULL COMMENT '设备名称',
  `zichanfenlei` varchar(200) DEFAULT NULL COMMENT '资产分类',
  `zichantupian` varchar(200) DEFAULT NULL COMMENT '资产图片',
  `shuliang` int NOT NULL COMMENT '数量',
  `jiechuriqi` date DEFAULT NULL COMMENT '借出日期',
  `jiechubeizhu` varchar(200) DEFAULT NULL COMMENT '借出备注',
  `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',
  `xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
  `shouji` varchar(200) DEFAULT NULL COMMENT '手机',
  `shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1716165785898 DEFAULT CHARSET=utf8 COMMENT='资产借出';

-- ----------------------------
-- Records of zichanjiechu
-- ----------------------------
BEGIN;
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (41, '2021-05-11 09:16:58', '资产编号1', '设备名称1', '资产分类1', 'http://localhost:8080/springboot4j9k2/upload/zichanjiechu_zichantupian1.jpg', 1, '2021-05-11', '借出备注1', '用户名1', '姓名1', '13823888881', '440300199101010001', '是', '');
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (42, '2021-05-11 09:16:58', '资产编号2', '设备名称2', '资产分类2', 'http://localhost:8080/springboot4j9k2/upload/zichanjiechu_zichantupian2.jpg', 2, '2021-05-11', '借出备注2', '用户名2', '姓名2', '13823888882', '440300199202020002', '是', '');
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (43, '2021-05-11 09:16:58', '资产编号3', '设备名称3', '资产分类3', 'http://localhost:8080/springboot4j9k2/upload/zichanjiechu_zichantupian3.jpg', 3, '2021-05-11', '借出备注3', '用户名3', '姓名3', '13823888883', '440300199303030003', '是', '');
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (44, '2021-05-11 09:16:58', '资产编号4', '设备名称4', '资产分类4', 'http://localhost:8080/springboot4j9k2/upload/zichanjiechu_zichantupian4.jpg', 4, '2021-05-11', '借出备注4', '用户名4', '姓名4', '13823888884', '440300199404040004', '是', '');
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (45, '2021-05-11 09:16:58', '资产编号5', '设备名称5', '资产分类5', 'http://localhost:8080/springboot4j9k2/upload/zichanjiechu_zichantupian5.jpg', 5, '2021-05-11', '借出备注5', '用户名5', '姓名5', '13823888885', '440300199505050005', '是', '');
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (46, '2021-05-11 09:16:58', '资产编号6', '设备名称6', '资产分类6', 'http://localhost:8080/springboot4j9k2/upload/zichanjiechu_zichantupian6.jpg', 6, '2021-05-11', '借出备注6', '用户名6', '姓名6', '13823888886', '440300199606060006', '是', '');
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (1712990731399, '2024-04-13 14:45:31', '资产编号1', '设备名称1', '资产分类1', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian1.jpg', 1, '2024-04-13', '12', '用户1', '姓名1', '13823888881', '440300199101010001', '是', NULL);
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (1716165783139, '2024-05-20 08:43:25', '资产编号1', '设备名称1', '资产分类1', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian1.jpg', 1, '2024-05-20', NULL, '212', '12', '17610830867', NULL, '否', NULL);
INSERT INTO `zichanjiechu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `jiechuriqi`, `jiechubeizhu`, `yonghuming`, `xingming`, `shouji`, `shenfenzheng`, `sfsh`, `shhf`) VALUES (1716165785897, '2024-05-20 08:43:22', '资产编号1', '设备名称1', '资产分类1', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian1.jpg', 1, '2024-05-20', NULL, '212', '12', '17610830867', NULL, '否', NULL);
COMMIT;

-- ----------------------------
-- Table structure for zichanweixiu
-- ----------------------------
DROP TABLE IF EXISTS `zichanweixiu`;
CREATE TABLE `zichanweixiu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zichanbianhao` varchar(200) NOT NULL COMMENT '资产编号',
  `shebeimingcheng` varchar(200) DEFAULT NULL COMMENT '设备名称',
  `zichanfenlei` varchar(200) DEFAULT NULL COMMENT '资产分类',
  `shuliang` int DEFAULT NULL COMMENT '数量',
  `weixiushuliang` int NOT NULL COMMENT '维修数量',
  `weixiushuoming` longtext COMMENT '维修说明',
  `weixiujindu` varchar(200) NOT NULL COMMENT '维修进度',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='资产维修';

-- ----------------------------
-- Records of zichanweixiu
-- ----------------------------
BEGIN;
INSERT INTO `zichanweixiu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `shuliang`, `weixiushuliang`, `weixiushuoming`, `weixiujindu`) VALUES (61, '2021-05-11 09:16:58', '资产编号1', '设备名称1', '资产分类1', 1, 1, '维修说明1', '维修中');
INSERT INTO `zichanweixiu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `shuliang`, `weixiushuliang`, `weixiushuoming`, `weixiujindu`) VALUES (62, '2021-05-11 09:16:58', '资产编号2', '设备名称2', '资产分类2', 2, 2, '维修说明2', '维修中');
INSERT INTO `zichanweixiu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `shuliang`, `weixiushuliang`, `weixiushuoming`, `weixiujindu`) VALUES (63, '2021-05-11 09:16:58', '资产编号3', '设备名称3', '资产分类3', 3, 3, '维修说明3', '维修中');
INSERT INTO `zichanweixiu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `shuliang`, `weixiushuliang`, `weixiushuoming`, `weixiujindu`) VALUES (64, '2021-05-11 09:16:58', '资产编号4', '设备名称4', '资产分类4', 4, 4, '维修说明4', '维修中');
INSERT INTO `zichanweixiu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `shuliang`, `weixiushuliang`, `weixiushuoming`, `weixiujindu`) VALUES (65, '2021-05-11 09:16:58', '资产编号5', '设备名称5', '资产分类5', 5, 5, '维修说明5', '维修中');
INSERT INTO `zichanweixiu` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `shuliang`, `weixiushuliang`, `weixiushuoming`, `weixiujindu`) VALUES (66, '2021-05-11 09:16:58', '资产编号6', '设备名称6', '资产分类6', 6, 6, '维修说明6', '维修中');
COMMIT;

-- ----------------------------
-- Table structure for zichanxinxi
-- ----------------------------
DROP TABLE IF EXISTS `zichanxinxi`;
CREATE TABLE `zichanxinxi` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `zichanbianhao` varchar(200) NOT NULL COMMENT '资产编号',
  `shebeimingcheng` varchar(200) DEFAULT NULL COMMENT '设备名称',
  `zichanfenlei` varchar(200) NOT NULL COMMENT '资产分类',
  `zichantupian` varchar(200) DEFAULT NULL COMMENT '资产图片',
  `shuliang` int NOT NULL COMMENT '数量',
  `beizhushuoming` varchar(200) DEFAULT NULL COMMENT '备注说明',
  `dangqianweizhi` varchar(200) DEFAULT NULL COMMENT '当前位置',
  PRIMARY KEY (`id`),
  UNIQUE KEY `zichanbianhao` (`zichanbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='资产信息';

-- ----------------------------
-- Records of zichanxinxi
-- ----------------------------
BEGIN;
INSERT INTO `zichanxinxi` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `beizhushuoming`, `dangqianweizhi`) VALUES (31, '2021-05-11 09:16:58', '资产编号1', '设备名称1', '资产分类1', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian1.jpg', 3, '备注说明1', '当前位置1');
INSERT INTO `zichanxinxi` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `beizhushuoming`, `dangqianweizhi`) VALUES (32, '2021-05-11 09:16:58', '资产编号2', '设备名称2', '资产分类2', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian2.jpg', 2, '备注说明2', '当前位置2');
INSERT INTO `zichanxinxi` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `beizhushuoming`, `dangqianweizhi`) VALUES (33, '2021-05-11 09:16:58', '资产编号3', '设备名称3', '资产分类3', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian3.jpg', 5, '备注说明3', '当前位置3');
INSERT INTO `zichanxinxi` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `beizhushuoming`, `dangqianweizhi`) VALUES (34, '2021-05-11 09:16:58', '资产编号4', '设备名称4', '资产分类4', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian4.jpg', 5, '备注说明4', '当前位置4');
INSERT INTO `zichanxinxi` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `beizhushuoming`, `dangqianweizhi`) VALUES (35, '2021-05-11 09:16:58', '资产编号5', '设备名称5', '资产分类5', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian5.jpg', 7, '备注说明5', '当前位置5');
INSERT INTO `zichanxinxi` (`id`, `addtime`, `zichanbianhao`, `shebeimingcheng`, `zichanfenlei`, `zichantupian`, `shuliang`, `beizhushuoming`, `dangqianweizhi`) VALUES (36, '2021-05-11 09:16:58', '资产编号6', '设备名称6', '资产分类6', 'http://localhost:8080/springboot4j9k2/upload/zichanxinxi_zichantupian6.jpg', 6, '备注说明6', '当前位置6');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
